﻿<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPageMcSigAdmin.master" AutoEventWireup="true" CodeFile="EstadoOrdenSalida.aspx.cs" Inherits="EstadoOrdenSalida" %>

<%@ Register assembly="DevExpress.Web.v12.2, Version=12.2.6.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxGridView" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.v12.2, Version=12.2.6.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxEditors" tagprefix="dx" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <table style="width:100%;">
        <tr>
            <td>
                <dx:ASPxGridView ID="ASPxGridView1" runat="server" AutoGenerateColumns="False" 
                    DataSourceID="SqlDataSource1" EnableTheming="True" KeyFieldName="AES_ID" 
                    Theme="PlasticBlue" Width="80%">
                    <Columns>
                        <dx:GridViewCommandColumn VisibleIndex="0">
                            <EditButton Visible="True">
                            </EditButton>
                            <NewButton Visible="True">
                            </NewButton>
                            <DeleteButton Visible="True">
                            </DeleteButton>
                            <ClearFilterButton Visible="True">
                            </ClearFilterButton>
                        </dx:GridViewCommandColumn>
                        <dx:GridViewDataTextColumn Caption="ID" FieldName="AES_ID" ReadOnly="True" 
                            VisibleIndex="1">
                            <EditFormSettings Visible="False" />
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Nombre" FieldName="AES_NOMBRE" 
                            VisibleIndex="2">
                        </dx:GridViewDataTextColumn>
                    </Columns>
                    <SettingsBehavior ConfirmDelete="True" />
                    <Settings ShowFilterRow="True" ShowTitlePanel="True" />
                    <SettingsText Title="Estados Orden Cargue" />
                </dx:ASPxGridView>
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:MCSIGConnectionString %>" 
                    DeleteCommand="DELETE FROM [AUT_ESTADOS_ORDEN_SALIDA] WHERE [AES_ID] = @AES_ID" 
                    InsertCommand="INSERT INTO [AUT_ESTADOS_ORDEN_SALIDA] ([AES_NOMBRE]) VALUES (@AES_NOMBRE)" 
                    SelectCommand="SELECT * FROM [AUT_ESTADOS_ORDEN_SALIDA]" 
                    UpdateCommand="UPDATE [AUT_ESTADOS_ORDEN_SALIDA] SET [AES_NOMBRE] = @AES_NOMBRE WHERE [AES_ID] = @AES_ID">
                    <DeleteParameters>
                        <asp:Parameter Name="AES_ID" Type="Decimal" />
                    </DeleteParameters>
                    <InsertParameters>
                        <asp:Parameter Name="AES_NOMBRE" Type="String" />
                    </InsertParameters>
                    <UpdateParameters>
                        <asp:Parameter Name="AES_NOMBRE" Type="String" />
                        <asp:Parameter Name="AES_ID" Type="Decimal" />
                    </UpdateParameters>
                </asp:SqlDataSource>
            </td>
        </tr>
        <tr>
            <td>
                &nbsp;</td>
        </tr>
        <tr>
            <td>
                &nbsp;</td>
        </tr>
    </table>
</asp:Content>

